package com.monitor.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.monitor.entity.ErpCustomerLimit;

/**
 * <p>
 * 客户物料寿命表 Mapper 接口
 * </p>
 *
 * @author LX
 * @since 2018-09-05
 */
public interface ErpCustomerLimitMapper extends BaseMapper<ErpCustomerLimit> {
	@Select("SELECT c.* from erp_customer_limit c where c.customer_id in (${cusIds}) and c.lim_enable=1 and ( c.lim_type='剩余胎纹' or c.lim_type='使用里程')")
	public List<ErpCustomerLimit> selectByCustIds(@Param("cusIds")String cusIds);
}
